﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Data.Common;
using System.Data.OleDb;

namespace PDFGenerator
{
    class GeneratorMain
    {
        static void Main()
        {         
            SQLReader s = new SQLReader("localhost", "supermarket", "root", "rootroot");
            Dictionary<int, NamePair> dic = new Dictionary<int, NamePair>(); dic = s.GetData();
            ExcelReader.FindExcels(@"C:\xp", dic);

            PDFWriter.PrintSalesReport(PDFWriter.ConvertToString(ExcelReader.products) , @"C:\xp\report.pdf");

        }
    }
}
